20 oktober, 2016

MySQL - remove CR+LF

Remove a Carriage Return and Line Feed from a MySQL table column:

UPDATE my_table SET my_column = replace(my_column,'\r\n',''); UPDATE my_table SET my_column = replace(my_column,'\n','');

MySQL

line feed carriage return